Working with Timestamps

The following important concepts must be considered when working with timestamps in data preparation operations.

UTC and Local Time

UTC: Temps Universel Coordonné, or Coordinated Universal Time.  Formerly known as GMT, or Greenwich Mean Time, this is the international standard of time.

Local Time: The current time in your area.

Operations using UTC time

Important: When configuring operations, all user configured timestamps will be treated as UTC time. All other operations will treat user configured timestamps as local time.

The following operations use UTC time:

• Add Fields: .NET Expression (all timestamp fields represents UTC time)

• Add Fields: .NET Script (all timestamp fields represents UTC time)

• Add Fields: SQL Expression

• Modify Dataset: SQL Update

• Transform Dataset: Transpose

• Filter Dataset: SQL Expression